Overview
Brought to you by YData
Dataset statistics
| Number of variables | 21 |
|---|---|
| Number of observations | 336776 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 102.2 MiB |
| Average record size in memory | 318.3 B |
Variable types
| Categorical | 5 |
|---|---|
| Numeric | 14 |
| Text | 1 |
| DateTime | 1 |
year has constant value "2013" | Constant |
dest has a high cardinality: 105 distinct values | High cardinality |
air_time is highly overall correlated with distance and 1 other fields | High correlation |
arr_delay is highly overall correlated with dep_delay | High correlation |
arr_time is highly overall correlated with dep_time and 3 other fields | High correlation |
carrier is highly overall correlated with origin | High correlation |
dep_delay is highly overall correlated with arr_delay | High correlation |
dep_time is highly overall correlated with arr_time and 3 other fields | High correlation |
distance is highly overall correlated with air_time and 1 other fields | High correlation |
hour is highly overall correlated with arr_time and 3 other fields | High correlation |
month is highly overall correlated with month_name | High correlation |
month_name is highly overall correlated with month | High correlation |
origin is highly overall correlated with carrier | High correlation |
sched_arr_time is highly overall correlated with arr_time and 3 other fields | High correlation |
sched_dep_time is highly overall correlated with arr_time and 3 other fields | High correlation |
speed is highly overall correlated with air_time and 1 other fields | High correlation |
dep_delay has 16514 (4.9%) zeros | Zeros |
arr_delay has 5409 (1.6%) zeros | Zeros |
minute has 60696 (18.0%) zeros | Zeros |
Reproduction
| Analysis started | 2025-05-24 03:45:54.573019 |
|---|---|
| Analysis finished | 2025-05-24 03:47:00.278368 |
| Duration | 1 minute and 5.71 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
year
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 19.6 MiB |
| 2013 |
|---|
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2013 |
|---|---|
| 2nd row | 2013 |
| 3rd row | 2013 |
| 4th row | 2013 |
| 5th row | 2013 |
Common Values
| Value | Count | Frequency (%) |
| 2013 | 336776 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2013 | 336776 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 336776 | |
| 0 | 336776 | |
| 1 | 336776 | |
| 3 | 336776 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1347104 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 336776 | |
| 0 | 336776 | |
| 1 | 336776 | |
| 3 | 336776 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1347104 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 336776 | |
| 0 | 336776 | |
| 1 | 336776 | |
| 3 | 336776 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1347104 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 336776 | |
| 0 | 336776 | |
| 1 | 336776 | |
| 3 | 336776 |
month
Real number (ℝ)
High correlation 
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.54851 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 7 |
| Q3 | 10 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.4144572 |
|---|---|
| Coefficient of variation (CV) | 0.52140979 |
| Kurtosis | -1.1869501 |
| Mean | 6.54851 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.013399885 |
| Sum | 2205381 |
| Variance | 11.658518 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 7 | 29425 | |
| 8 | 29327 | |
| 10 | 28889 | |
| 3 | 28834 | |
| 5 | 28796 | |
| 4 | 28330 | |
| 6 | 28243 | |
| 12 | 28135 | |
| 9 | 27574 | |
| 11 | 27268 | |
| Other values (2) | 51955 |
| Value | Count | Frequency (%) |
| 1 | 27004 | |
| 2 | 24951 | |
| 3 | 28834 | |
| 4 | 28330 | |
| 5 | 28796 | |
| 6 | 28243 | |
| 7 | 29425 | |
| 8 | 29327 | |
| 9 | 27574 | |
| 10 | 28889 |
| Value | Count | Frequency (%) |
| 12 | 28135 | |
| 11 | 27268 | |
| 10 | 28889 | |
| 9 | 27574 | |
| 8 | 29327 | |
| 7 | 29425 | |
| 6 | 28243 | |
| 5 | 28796 | |
| 4 | 28330 | |
| 3 | 28834 |
day
Real number (ℝ)
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.710787 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 23 |
| 95-th percentile | 29 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.7686071 |
|---|---|
| Coefficient of variation (CV) | 0.55812653 |
| Kurtosis | -1.1859454 |
| Mean | 15.710787 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.0077444993 |
| Sum | 5291016 |
| Variance | 76.888471 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 18 | 11399 | 3.4% |
| 11 | 11359 | 3.4% |
| 22 | 11345 | 3.4% |
| 15 | 11317 | 3.4% |
| 8 | 11271 | 3.3% |
| 10 | 11227 | 3.3% |
| 17 | 11222 | 3.3% |
| 3 | 11211 | 3.3% |
| 21 | 11141 | 3.3% |
| 20 | 11111 | 3.3% |
| Other values (21) | 224173 |
| Value | Count | Frequency (%) |
| 1 | 11036 | |
| 2 | 10808 | |
| 3 | 11211 | |
| 4 | 11059 | |
| 5 | 10858 | |
| 6 | 11059 | |
| 7 | 10985 | |
| 8 | 11271 | |
| 9 | 10857 | |
| 10 | 11227 |
| Value | Count | Frequency (%) |
| 31 | 6190 | |
| 30 | 10289 | |
| 29 | 10039 | |
| 28 | 10773 | |
| 27 | 11084 | |
| 26 | 10883 | |
| 25 | 11097 | |
| 24 | 11041 | |
| 23 | 10966 | |
| 22 | 11345 |
dep_time
Real number (ℝ)
High correlation 
| Distinct | 1319 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1349.1099 |
| Minimum | 1 |
|---|---|
| Maximum | 2400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 625 |
| Q1 | 915 |
| median | 1349.1099 |
| Q3 | 1737 |
| 95-th percentile | 2110 |
| Maximum | 2400 |
| Range | 2399 |
| Interquartile range (IQR) | 822 |
Descriptive statistics
| Standard deviation | 482.2603 |
|---|---|
| Coefficient of variation (CV) | 0.35746553 |
| Kurtosis | -1.0402831 |
| Mean | 1349.1099 |
| Median Absolute Deviation (MAD) | 408.89005 |
| Skewness | -0.025052395 |
| Sum | 4.5434785 × 108 |
| Variance | 232575 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1349.109947 | 8255 | 2.5% |
| 555 | 834 | 0.2% |
| 755 | 820 | 0.2% |
| 556 | 818 | 0.2% |
| 557 | 799 | 0.2% |
| 655 | 798 | 0.2% |
| 1455 | 774 | 0.2% |
| 1454 | 769 | 0.2% |
| 654 | 751 | 0.2% |
| 855 | 743 | 0.2% |
| Other values (1309) | 321415 |
| Value | Count | Frequency (%) |
| 1 | 25 | |
| 2 | 35 | |
| 3 | 26 | |
| 4 | 26 | |
| 5 | 21 | |
| 6 | 22 | |
| 7 | 22 | |
| 8 | 23 | |
| 9 | 28 | |
| 10 | 22 |
| Value | Count | Frequency (%) |
| 2400 | 29 | < 0.1% |
| 2359 | 55 | |
| 2358 | 76 | |
| 2357 | 74 | |
| 2356 | 74 | |
| 2355 | 82 | |
| 2354 | 69 | |
| 2353 | 68 | |
| 2352 | 68 | |
| 2351 | 57 |
sched_dep_time
Real number (ℝ)
High correlation 
| Distinct | 1021 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1344.2548 |
| Minimum | 106 |
|---|---|
| Maximum | 2359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 106 |
|---|---|
| 5-th percentile | 630 |
| Q1 | 906 |
| median | 1359 |
| Q3 | 1729 |
| 95-th percentile | 2050 |
| Maximum | 2359 |
| Range | 2253 |
| Interquartile range (IQR) | 823 |
Descriptive statistics
| Standard deviation | 467.33576 |
|---|---|
| Coefficient of variation (CV) | 0.34765414 |
| Kurtosis | -1.1979031 |
| Mean | 1344.2548 |
| Median Absolute Deviation (MAD) | 414 |
| Skewness | -0.0058580829 |
| Sum | 4.5271277 × 108 |
| Variance | 218402.71 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 600 | 7016 | 2.1% |
| 700 | 4900 | 1.5% |
| 630 | 4770 | 1.4% |
| 900 | 4766 | 1.4% |
| 1200 | 4624 | 1.4% |
| 1700 | 4526 | 1.3% |
| 1600 | 4098 | 1.2% |
| 800 | 3926 | 1.2% |
| 1300 | 3689 | 1.1% |
| 1900 | 3653 | 1.1% |
| Other values (1011) | 290808 |
| Value | Count | Frequency (%) |
| 106 | 1 | < 0.1% |
| 500 | 341 | |
| 501 | 1 | < 0.1% |
| 505 | 2 | < 0.1% |
| 510 | 5 | < 0.1% |
| 515 | 208 | |
| 516 | 4 | < 0.1% |
| 517 | 28 | < 0.1% |
| 520 | 7 | < 0.1% |
| 525 | 37 | < 0.1% |
| Value | Count | Frequency (%) |
| 2359 | 828 | |
| 2358 | 44 | < 0.1% |
| 2355 | 73 | < 0.1% |
| 2352 | 16 | < 0.1% |
| 2345 | 1 | < 0.1% |
| 2339 | 1 | < 0.1% |
| 2330 | 14 | < 0.1% |
| 2315 | 1 | < 0.1% |
| 2305 | 61 | < 0.1% |
| 2300 | 22 | < 0.1% |
dep_delay
Real number (ℝ)
High correlation  Zeros 
| Distinct | 528 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.63907 |
| Minimum | -43 |
|---|---|
| Maximum | 1301 |
| Zeros | 16514 |
| Zeros (%) | 4.9% |
| Negative | 183575 |
| Negative (%) | 54.5% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | -43 |
|---|---|
| 5-th percentile | -9 |
| Q1 | -5 |
| median | -1 |
| Q3 | 12.63907 |
| 95-th percentile | 87 |
| Maximum | 1301 |
| Range | 1344 |
| Interquartile range (IQR) | 17.63907 |
Descriptive statistics
| Standard deviation | 39.714191 |
|---|---|
| Coefficient of variation (CV) | 3.1421766 |
| Kurtosis | 45.129851 |
| Mean | 12.63907 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 4.8625042 |
| Sum | 4256535.5 |
| Variance | 1577.2169 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -5 | 24821 | 7.4% |
| -4 | 24619 | 7.3% |
| -3 | 24218 | 7.2% |
| -2 | 21516 | 6.4% |
| -6 | 20701 | 6.1% |
| -1 | 18813 | 5.6% |
| -7 | 16752 | 5.0% |
| 0 | 16514 | 4.9% |
| -8 | 11791 | 3.5% |
| 12.63907026 | 8255 | 2.5% |
| Other values (518) | 148776 |
| Value | Count | Frequency (%) |
| -43 | 1 | < 0.1% |
| -33 | 1 | < 0.1% |
| -32 | 1 | < 0.1% |
| -30 | 1 | < 0.1% |
| -27 | 1 | < 0.1% |
| -26 | 1 | < 0.1% |
| -25 | 2 | < 0.1% |
| -24 | 4 | < 0.1% |
| -23 | 6 | |
| -22 | 11 |
| Value | Count | Frequency (%) |
| 1301 | 1 | |
| 1137 | 1 | |
| 1126 | 1 | |
| 1014 | 1 | |
| 1005 | 1 | |
| 960 | 1 | |
| 911 | 1 | |
| 899 | 1 | |
| 898 | 1 | |
| 896 | 1 |
arr_time
Real number (ℝ)
High correlation 
| Distinct | 1412 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1502.055 |
| Minimum | 1 |
|---|---|
| Maximum | 2400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 739 |
| Q1 | 1110 |
| median | 1518 |
| Q3 | 1934 |
| 95-th percentile | 2247 |
| Maximum | 2400 |
| Range | 2399 |
| Interquartile range (IQR) | 824 |
Descriptive statistics
| Standard deviation | 526.32066 |
|---|---|
| Coefficient of variation (CV) | 0.35040039 |
| Kurtosis | -0.11807347 |
| Mean | 1502.055 |
| Median Absolute Deviation (MAD) | 412 |
| Skewness | -0.47399068 |
| Sum | 5.0585607 × 108 |
| Variance | 277013.43 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1502.054999 | 8713 | 2.6% |
| 1008 | 485 | 0.1% |
| 1013 | 484 | 0.1% |
| 1015 | 479 | 0.1% |
| 1012 | 464 | 0.1% |
| 1005 | 460 | 0.1% |
| 1016 | 459 | 0.1% |
| 1006 | 459 | 0.1% |
| 1011 | 457 | 0.1% |
| 1007 | 456 | 0.1% |
| Other values (1402) | 323860 |
| Value | Count | Frequency (%) |
| 1 | 201 | |
| 2 | 164 | |
| 3 | 174 | |
| 4 | 173 | |
| 5 | 206 | |
| 6 | 148 | |
| 7 | 170 | |
| 8 | 147 | |
| 9 | 140 | |
| 10 | 178 |
| Value | Count | Frequency (%) |
| 2400 | 150 | |
| 2359 | 222 | |
| 2358 | 189 | |
| 2357 | 207 | |
| 2356 | 202 | |
| 2355 | 206 | |
| 2354 | 195 | |
| 2353 | 182 | |
| 2352 | 193 | |
| 2351 | 216 |
sched_arr_time
Real number (ℝ)
High correlation 
| Distinct | 1163 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1536.3802 |
| Minimum | 1 |
|---|---|
| Maximum | 2359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 815 |
| Q1 | 1124 |
| median | 1556 |
| Q3 | 1945 |
| 95-th percentile | 2246 |
| Maximum | 2359 |
| Range | 2358 |
| Interquartile range (IQR) | 821 |
Descriptive statistics
| Standard deviation | 497.45714 |
|---|---|
| Coefficient of variation (CV) | 0.32378518 |
| Kurtosis | -0.38224779 |
| Mean | 1536.3802 |
| Median Absolute Deviation (MAD) | 417 |
| Skewness | -0.35313807 |
| Sum | 5.1741598 × 108 |
| Variance | 247463.61 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1025 | 1324 | 0.4% |
| 2015 | 1234 | 0.4% |
| 1110 | 1198 | 0.4% |
| 1115 | 1193 | 0.4% |
| 1235 | 1133 | 0.3% |
| 2359 | 1121 | 0.3% |
| 1815 | 1111 | 0.3% |
| 1015 | 1080 | 0.3% |
| 1645 | 1079 | 0.3% |
| 1220 | 1073 | 0.3% |
| Other values (1153) | 325230 |
| Value | Count | Frequency (%) |
| 1 | 243 | |
| 2 | 95 | < 0.1% |
| 3 | 159 | |
| 4 | 107 | |
| 5 | 82 | < 0.1% |
| 6 | 19 | < 0.1% |
| 7 | 85 | < 0.1% |
| 8 | 154 | |
| 9 | 55 | < 0.1% |
| 10 | 72 | < 0.1% |
| Value | Count | Frequency (%) |
| 2359 | 1121 | |
| 2358 | 483 | |
| 2357 | 349 | 0.1% |
| 2356 | 468 | |
| 2355 | 335 | 0.1% |
| 2354 | 384 | 0.1% |
| 2353 | 263 | 0.1% |
| 2352 | 47 | < 0.1% |
| 2351 | 140 | < 0.1% |
| 2350 | 105 | < 0.1% |
arr_delay
Real number (ℝ)
High correlation  Zeros 
| Distinct | 578 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.8953768 |
| Minimum | -86 |
|---|---|
| Maximum | 1272 |
| Zeros | 5409 |
| Zeros (%) | 1.6% |
| Negative | 188933 |
| Negative (%) | 56.1% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | -86 |
|---|---|
| 5-th percentile | -32 |
| Q1 | -16 |
| median | -4 |
| Q3 | 13 |
| 95-th percentile | 89 |
| Maximum | 1272 |
| Range | 1358 |
| Interquartile range (IQR) | 29 |
Descriptive statistics
| Standard deviation | 44.003969 |
|---|---|
| Coefficient of variation (CV) | 6.3816628 |
| Kurtosis | 30.161583 |
| Mean | 6.8953768 |
| Median Absolute Deviation (MAD) | 14 |
| Skewness | 3.7699729 |
| Sum | 2322197.4 |
| Variance | 1936.3493 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 6.895376757 | 9430 | 2.8% |
| -13 | 7177 | 2.1% |
| -10 | 7088 | 2.1% |
| -12 | 7046 | 2.1% |
| -14 | 6975 | 2.1% |
| -11 | 6863 | 2.0% |
| -9 | 6815 | 2.0% |
| -15 | 6796 | 2.0% |
| -7 | 6677 | 2.0% |
| -17 | 6668 | 2.0% |
| Other values (568) | 265241 |
| Value | Count | Frequency (%) |
| -86 | 1 | < 0.1% |
| -79 | 1 | < 0.1% |
| -75 | 2 | < 0.1% |
| -74 | 1 | < 0.1% |
| -73 | 1 | < 0.1% |
| -71 | 3 | < 0.1% |
| -70 | 8 | |
| -69 | 7 | |
| -68 | 12 | |
| -67 | 7 |
| Value | Count | Frequency (%) |
| 1272 | 1 | |
| 1127 | 1 | |
| 1109 | 1 | |
| 1007 | 1 | |
| 989 | 1 | |
| 931 | 1 | |
| 915 | 1 | |
| 895 | 1 | |
| 878 | 1 | |
| 875 | 1 |
carrier
Categorical
High correlation 
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 330.5 KiB |
| UA | |
|---|---|
| B6 | |
| EV | |
| DL | |
| AA | |
| Other values (11) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | UA |
|---|---|
| 2nd row | UA |
| 3rd row | AA |
| 4th row | B6 |
| 5th row | DL |
Common Values
| Value | Count | Frequency (%) |
| UA | 58665 | |
| B6 | 54635 | |
| EV | 54173 | |
| DL | 48110 | |
| AA | 32729 | |
| MQ | 26397 | |
| US | 20536 | 6.1% |
| 9E | 18460 | 5.5% |
| WN | 12275 | 3.6% |
| VX | 5162 | 1.5% |
| Other values (6) | 5634 | 1.7% |
Length
| Value | Count | Frequency (%) |
| ua | 58665 | |
| b6 | 54635 | |
| ev | 54173 | |
| dl | 48110 | |
| aa | 32729 | |
| mq | 26397 | |
| us | 20536 | 6.1% |
| 9e | 18460 | 5.5% |
| wn | 12275 | 3.6% |
| vx | 5162 | 1.5% |
| Other values (6) | 5634 | 1.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 125179 | |
| U | 79201 | |
| E | 72633 | |
| V | 59936 | |
| B | 54635 | |
| 6 | 54635 | |
| L | 51370 | |
| D | 48110 | 7.1% |
| Q | 26397 | 3.9% |
| M | 26397 | 3.9% |
| Other values (9) | 75059 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 599772 | |
| Decimal Number | 73780 | 11.0% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 125179 | |
| U | 79201 | |
| E | 72633 | |
| V | 59936 | |
| B | 54635 | |
| L | 51370 | |
| D | 48110 | 8.0% |
| Q | 26397 | 4.4% |
| M | 26397 | 4.4% |
| S | 21250 | 3.5% |
| Other values (7) | 34664 | 5.8% |
Decimal Number
| Value | Count | Frequency (%) |
| 6 | 54635 | |
| 9 | 19145 | 25.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 599772 | |
| Common | 73780 | 11.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 125179 | |
| U | 79201 | |
| E | 72633 | |
| V | 59936 | |
| B | 54635 | |
| L | 51370 | |
| D | 48110 | 8.0% |
| Q | 26397 | 4.4% |
| M | 26397 | 4.4% |
| S | 21250 | 3.5% |
| Other values (7) | 34664 | 5.8% |
Common
| Value | Count | Frequency (%) |
| 6 | 54635 | |
| 9 | 19145 | 25.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 673552 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 125179 | |
| U | 79201 | |
| E | 72633 | |
| V | 59936 | |
| B | 54635 | |
| 6 | 54635 | |
| L | 51370 | |
| D | 48110 | 7.1% |
| Q | 26397 | 3.9% |
| M | 26397 | 3.9% |
| Other values (9) | 75059 |
flight
Real number (ℝ)
| Distinct | 3844 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1971.9236 |
| Minimum | 1 |
|---|---|
| Maximum | 8500 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 91 |
| Q1 | 553 |
| median | 1496 |
| Q3 | 3465 |
| 95-th percentile | 4695 |
| Maximum | 8500 |
| Range | 8499 |
| Interquartile range (IQR) | 2912 |
Descriptive statistics
| Standard deviation | 1632.4719 |
|---|---|
| Coefficient of variation (CV) | 0.82785759 |
| Kurtosis | -0.84856068 |
| Mean | 1971.9236 |
| Median Absolute Deviation (MAD) | 1085 |
| Skewness | 0.66160363 |
| Sum | 6.6409655 × 108 |
| Variance | 2664964.6 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 15 | 968 | 0.3% |
| 27 | 898 | 0.3% |
| 181 | 882 | 0.3% |
| 301 | 871 | 0.3% |
| 161 | 786 | 0.2% |
| 695 | 782 | 0.2% |
| 1109 | 716 | 0.2% |
| 745 | 711 | 0.2% |
| 359 | 709 | 0.2% |
| 1 | 701 | 0.2% |
| Other values (3834) | 328752 |
| Value | Count | Frequency (%) |
| 1 | 701 | |
| 2 | 51 | < 0.1% |
| 3 | 631 | |
| 4 | 393 | |
| 5 | 324 | |
| 6 | 210 | 0.1% |
| 7 | 237 | 0.1% |
| 8 | 236 | 0.1% |
| 9 | 153 | < 0.1% |
| 10 | 61 | < 0.1% |
| Value | Count | Frequency (%) |
| 8500 | 1 | < 0.1% |
| 6181 | 80 | |
| 6180 | 6 | < 0.1% |
| 6177 | 164 | |
| 6171 | 1 | < 0.1% |
| 6168 | 2 | < 0.1% |
| 6167 | 3 | < 0.1% |
| 6165 | 1 | < 0.1% |
| 6140 | 1 | < 0.1% |
| 6138 | 2 | < 0.1% |
tailnum
Text
| Distinct | 4043 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 20.2 MiB |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 5.995258 |
| Min length | 5 |
Unique
| Unique | 171 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | N14228 |
|---|---|
| 2nd row | N24211 |
| 3rd row | N619AA |
| 4th row | N804JB |
| 5th row | N668DN |
| Value | Count | Frequency (%) |
| n725mq | 3087 | 0.9% |
| n722mq | 513 | 0.2% |
| n723mq | 507 | 0.2% |
| n711mq | 486 | 0.1% |
| n713mq | 483 | 0.1% |
| n258jb | 427 | 0.1% |
| n298jb | 407 | 0.1% |
| n353jb | 404 | 0.1% |
| n351jb | 402 | 0.1% |
| n735mq | 396 | 0.1% |
| Other values (4033) | 329664 |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 363324 | |
| 3 | 149395 | 7.4% |
| 1 | 145378 | 7.2% |
| 5 | 138064 | 6.8% |
| A | 118723 | 5.9% |
| 7 | 117211 | 5.8% |
| 2 | 112564 | 5.6% |
| 9 | 106405 | 5.3% |
| 4 | 102253 | 5.1% |
| 6 | 101332 | 5.0% |
| Other values (24) | 564410 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1125587 | |
| Uppercase Letter | 893472 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 363324 | |
| A | 118723 | 13.3% |
| B | 69014 | 7.7% |
| J | 66843 | 7.5% |
| U | 46341 | 5.2% |
| W | 35652 | 4.0% |
| Q | 32249 | 3.6% |
| M | 30261 | 3.4% |
| D | 24010 | 2.7% |
| E | 14851 | 1.7% |
| Other values (14) | 92204 | 10.3% |
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 149395 | |
| 1 | 145378 | |
| 5 | 138064 | |
| 7 | 117211 | |
| 2 | 112564 | |
| 9 | 106405 | |
| 4 | 102253 | |
| 6 | 101332 | |
| 8 | 84315 | |
| 0 | 68670 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1125587 | |
| Latin | 893472 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 363324 | |
| A | 118723 | 13.3% |
| B | 69014 | 7.7% |
| J | 66843 | 7.5% |
| U | 46341 | 5.2% |
| W | 35652 | 4.0% |
| Q | 32249 | 3.6% |
| M | 30261 | 3.4% |
| D | 24010 | 2.7% |
| E | 14851 | 1.7% |
| Other values (14) | 92204 | 10.3% |
Common
| Value | Count | Frequency (%) |
| 3 | 149395 | |
| 1 | 145378 | |
| 5 | 138064 | |
| 7 | 117211 | |
| 2 | 112564 | |
| 9 | 106405 | |
| 4 | 102253 | |
| 6 | 101332 | |
| 8 | 84315 | |
| 0 | 68670 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2019059 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| N | 363324 | |
| 3 | 149395 | 7.4% |
| 1 | 145378 | 7.2% |
| 5 | 138064 | 6.8% |
| A | 118723 | 5.9% |
| 7 | 117211 | 5.8% |
| 2 | 112564 | 5.6% |
| 9 | 106405 | 5.3% |
| 4 | 102253 | 5.1% |
| 6 | 101332 | 5.0% |
| Other values (24) | 564410 |
origin
Categorical
High correlation 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 329.3 KiB |
| EWR | |
|---|---|
| JFK | |
| LGA |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | EWR |
|---|---|
| 2nd row | LGA |
| 3rd row | JFK |
| 4th row | JFK |
| 5th row | LGA |
Common Values
| Value | Count | Frequency (%) |
| EWR | 120835 | |
| JFK | 111279 | |
| LGA | 104662 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| ewr | 120835 | |
| jfk | 111279 | |
| lga | 104662 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 120835 | |
| W | 120835 | |
| R | 120835 | |
| J | 111279 | |
| F | 111279 | |
| K | 111279 | |
| L | 104662 | |
| G | 104662 | |
| A | 104662 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1010328 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 120835 | |
| W | 120835 | |
| R | 120835 | |
| J | 111279 | |
| F | 111279 | |
| K | 111279 | |
| L | 104662 | |
| G | 104662 | |
| A | 104662 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1010328 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 120835 | |
| W | 120835 | |
| R | 120835 | |
| J | 111279 | |
| F | 111279 | |
| K | 111279 | |
| L | 104662 | |
| G | 104662 | |
| A | 104662 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1010328 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 120835 | |
| W | 120835 | |
| R | 120835 | |
| J | 111279 | |
| F | 111279 | |
| K | 111279 | |
| L | 104662 | |
| G | 104662 | |
| A | 104662 |
dest
Categorical
High cardinality 
| Distinct | 105 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 339.2 KiB |
| ORD | 17283 |
|---|---|
| ATL | 17215 |
| LAX | 16174 |
| BOS | 15508 |
| MCO | 14082 |
| Other values (100) |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | IAH |
|---|---|
| 2nd row | IAH |
| 3rd row | MIA |
| 4th row | BQN |
| 5th row | ATL |
Common Values
| Value | Count | Frequency (%) |
| ORD | 17283 | 5.1% |
| ATL | 17215 | 5.1% |
| LAX | 16174 | 4.8% |
| BOS | 15508 | 4.6% |
| MCO | 14082 | 4.2% |
| CLT | 14064 | 4.2% |
| SFO | 13331 | 4.0% |
| FLL | 12055 | 3.6% |
| MIA | 11728 | 3.5% |
| DCA | 9705 | 2.9% |
| Other values (95) | 195631 |
Length
| Value | Count | Frequency (%) |
| ord | 17283 | 5.1% |
| atl | 17215 | 5.1% |
| lax | 16174 | 4.8% |
| bos | 15508 | 4.6% |
| mco | 14082 | 4.2% |
| clt | 14064 | 4.2% |
| sfo | 13331 | 4.0% |
| fll | 12055 | 3.6% |
| mia | 11728 | 3.5% |
| dca | 9705 | 2.9% |
| Other values (95) | 195631 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 107619 | 10.7% |
| L | 93530 | 9.3% |
| S | 86165 | 8.5% |
| D | 77868 | 7.7% |
| O | 69436 | 6.9% |
| C | 64362 | 6.4% |
| T | 61733 | 6.1% |
| M | 59156 | 5.9% |
| I | 42485 | 4.2% |
| F | 41782 | 4.1% |
| Other values (16) | 306192 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1010328 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 107619 | 10.7% |
| L | 93530 | 9.3% |
| S | 86165 | 8.5% |
| D | 77868 | 7.7% |
| O | 69436 | 6.9% |
| C | 64362 | 6.4% |
| T | 61733 | 6.1% |
| M | 59156 | 5.9% |
| I | 42485 | 4.2% |
| F | 41782 | 4.1% |
| Other values (16) | 306192 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1010328 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 107619 | 10.7% |
| L | 93530 | 9.3% |
| S | 86165 | 8.5% |
| D | 77868 | 7.7% |
| O | 69436 | 6.9% |
| C | 64362 | 6.4% |
| T | 61733 | 6.1% |
| M | 59156 | 5.9% |
| I | 42485 | 4.2% |
| F | 41782 | 4.1% |
| Other values (16) | 306192 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1010328 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 107619 | 10.7% |
| L | 93530 | 9.3% |
| S | 86165 | 8.5% |
| D | 77868 | 7.7% |
| O | 69436 | 6.9% |
| C | 64362 | 6.4% |
| T | 61733 | 6.1% |
| M | 59156 | 5.9% |
| I | 42485 | 4.2% |
| F | 41782 | 4.1% |
| Other values (16) | 306192 |
air_time
Real number (ℝ)
High correlation 
| Distinct | 510 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 150.68646 |
| Minimum | 20 |
|---|---|
| Maximum | 695 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 20 |
|---|---|
| 5-th percentile | 40 |
| Q1 | 84 |
| median | 132 |
| Q3 | 188 |
| 95-th percentile | 339 |
| Maximum | 695 |
| Range | 675 |
| Interquartile range (IQR) | 104 |
Descriptive statistics
| Standard deviation | 92.367314 |
|---|---|
| Coefficient of variation (CV) | 0.61297686 |
| Kurtosis | 0.97436221 |
| Mean | 150.68646 |
| Median Absolute Deviation (MAD) | 51 |
| Skewness | 1.0860177 |
| Sum | 50747583 |
| Variance | 8531.7207 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 150.6864602 | 9430 | 2.8% |
| 42 | 2552 | 0.8% |
| 43 | 2543 | 0.8% |
| 41 | 2513 | 0.7% |
| 45 | 2495 | 0.7% |
| 40 | 2466 | 0.7% |
| 44 | 2444 | 0.7% |
| 39 | 2411 | 0.7% |
| 47 | 2409 | 0.7% |
| 46 | 2406 | 0.7% |
| Other values (500) | 305107 |
| Value | Count | Frequency (%) |
| 20 | 2 | < 0.1% |
| 21 | 14 | < 0.1% |
| 22 | 34 | < 0.1% |
| 23 | 82 | < 0.1% |
| 24 | 103 | |
| 25 | 124 | |
| 26 | 169 | |
| 27 | 147 | |
| 28 | 180 | |
| 29 | 209 |
| Value | Count | Frequency (%) |
| 695 | 1 | |
| 691 | 1 | |
| 686 | 2 | |
| 683 | 1 | |
| 679 | 1 | |
| 676 | 2 | |
| 675 | 1 | |
| 671 | 2 | |
| 669 | 1 | |
| 667 | 2 |
distance
Real number (ℝ)
High correlation 
| Distinct | 214 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1039.9126 |
| Minimum | 17 |
|---|---|
| Maximum | 4983 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 17 |
|---|---|
| 5-th percentile | 199 |
| Q1 | 502 |
| median | 872 |
| Q3 | 1389 |
| 95-th percentile | 2475 |
| Maximum | 4983 |
| Range | 4966 |
| Interquartile range (IQR) | 887 |
Descriptive statistics
| Standard deviation | 733.23303 |
|---|---|
| Coefficient of variation (CV) | 0.70509102 |
| Kurtosis | 1.1936399 |
| Mean | 1039.9126 |
| Median Absolute Deviation (MAD) | 384 |
| Skewness | 1.1286902 |
| Sum | 3.5021761 × 108 |
| Variance | 537630.68 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2475 | 11262 | 3.3% |
| 762 | 10263 | 3.0% |
| 733 | 8857 | 2.6% |
| 2586 | 8204 | 2.4% |
| 544 | 6168 | 1.8% |
| 719 | 6100 | 1.8% |
| 187 | 5898 | 1.8% |
| 1096 | 5781 | 1.7% |
| 2454 | 5695 | 1.7% |
| 184 | 5504 | 1.6% |
| Other values (204) | 263044 |
| Value | Count | Frequency (%) |
| 17 | 1 | < 0.1% |
| 80 | 49 | < 0.1% |
| 94 | 976 | 0.3% |
| 96 | 607 | 0.2% |
| 116 | 443 | 0.1% |
| 143 | 439 | 0.1% |
| 160 | 376 | 0.1% |
| 169 | 545 | 0.2% |
| 173 | 221 | 0.1% |
| 184 | 5504 |
| Value | Count | Frequency (%) |
| 4983 | 342 | 0.1% |
| 4963 | 365 | 0.1% |
| 3370 | 8 | < 0.1% |
| 2586 | 8204 | |
| 2576 | 312 | 0.1% |
| 2569 | 329 | 0.1% |
| 2565 | 5127 | |
| 2521 | 284 | 0.1% |
| 2475 | 11262 | |
| 2465 | 1039 | 0.3% |
hour
Real number (ℝ)
High correlation 
| Distinct | 20 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.180247 |
| Minimum | 1 |
|---|---|
| Maximum | 23 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 9 |
| median | 13 |
| Q3 | 17 |
| 95-th percentile | 20 |
| Maximum | 23 |
| Range | 22 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 4.6613157 |
|---|---|
| Coefficient of variation (CV) | 0.3536592 |
| Kurtosis | -1.2064161 |
| Mean | 13.180247 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | -0.00054265178 |
| Sum | 4438791 |
| Variance | 21.727864 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 8 | 27242 | 8.1% |
| 6 | 25951 | 7.7% |
| 17 | 24426 | 7.3% |
| 15 | 23888 | 7.1% |
| 16 | 23002 | 6.8% |
| 7 | 22821 | 6.8% |
| 18 | 21783 | 6.5% |
| 14 | 21706 | 6.4% |
| 19 | 21441 | 6.4% |
| 9 | 20312 | 6.0% |
| Other values (10) | 104204 |
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 5 | 1953 | 0.6% |
| 6 | 25951 | |
| 7 | 22821 | |
| 8 | 27242 | |
| 9 | 20312 | |
| 10 | 16708 | |
| 11 | 16033 | |
| 12 | 18181 | |
| 13 | 19956 |
| Value | Count | Frequency (%) |
| 23 | 1061 | 0.3% |
| 22 | 2639 | 0.8% |
| 21 | 10933 | |
| 20 | 16739 | |
| 19 | 21441 | |
| 18 | 21783 | |
| 17 | 24426 | |
| 16 | 23002 | |
| 15 | 23888 | |
| 14 | 21706 |
minute
Real number (ℝ)
Zeros 
| Distinct | 60 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26.2301 |
| Minimum | 0 |
|---|---|
| Maximum | 59 |
| Zeros | 60696 |
| Zeros (%) | 18.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 8 |
| median | 29 |
| Q3 | 44 |
| 95-th percentile | 58 |
| Maximum | 59 |
| Range | 59 |
| Interquartile range (IQR) | 36 |
Descriptive statistics
| Standard deviation | 19.300846 |
|---|---|
| Coefficient of variation (CV) | 0.73582815 |
| Kurtosis | -1.235018 |
| Mean | 26.2301 |
| Median Absolute Deviation (MAD) | 16 |
| Skewness | 0.092930947 |
| Sum | 8833668 |
| Variance | 372.52264 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 60696 | |
| 30 | 33899 | 10.1% |
| 45 | 20398 | 6.1% |
| 15 | 18868 | 5.6% |
| 55 | 18834 | 5.6% |
| 59 | 16288 | 4.8% |
| 10 | 14503 | 4.3% |
| 25 | 14450 | 4.3% |
| 5 | 14118 | 4.2% |
| 29 | 13823 | 4.1% |
| Other values (50) | 110899 |
| Value | Count | Frequency (%) |
| 0 | 60696 | |
| 1 | 2116 | 0.6% |
| 2 | 848 | 0.3% |
| 3 | 1439 | 0.4% |
| 4 | 1357 | 0.4% |
| 5 | 14118 | 4.2% |
| 6 | 1381 | 0.4% |
| 7 | 1092 | 0.3% |
| 8 | 1695 | 0.5% |
| 9 | 1445 | 0.4% |
| Value | Count | Frequency (%) |
| 59 | 16288 | |
| 58 | 1065 | 0.3% |
| 57 | 1388 | 0.4% |
| 56 | 1713 | 0.5% |
| 55 | 18834 | |
| 54 | 1405 | 0.4% |
| 53 | 1382 | 0.4% |
| 52 | 1281 | 0.4% |
| 51 | 1184 | 0.4% |
| 50 | 12508 |
time_hour
Date
| Distinct | 6936 |
|---|---|
| Distinct (%) | 2.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.6 MiB |
| Minimum | 2013-01-01 05:00:00 |
|---|---|
| Maximum | 2013-12-31 23:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
speed
Real number (ℝ)
High correlation 
| Distinct | 10446 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 391.55421 |
| Minimum | 6.7690222 |
|---|---|
| Maximum | 1976.1563 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 6.7690222 |
|---|---|
| 5-th percentile | 272.72727 |
| Q1 | 354.44444 |
| median | 403.17757 |
| Q3 | 438.42857 |
| 95-th percentile | 478.05195 |
| Maximum | 1976.1563 |
| Range | 1969.3873 |
| Interquartile range (IQR) | 83.984127 |
Descriptive statistics
| Standard deviation | 72.231438 |
|---|---|
| Coefficient of variation (CV) | 0.18447366 |
| Kurtosis | 12.264648 |
| Mean | 391.55421 |
| Median Absolute Deviation (MAD) | 40.206116 |
| Skewness | 0.018411446 |
| Sum | 1.3186606 × 108 |
| Variance | 5217.3806 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 330 | 827 | 0.2% |
| 450 | 784 | 0.2% |
| 300 | 646 | 0.2% |
| 340 | 630 | 0.2% |
| 290.5263158 | 553 | 0.2% |
| 420 | 551 | 0.2% |
| 280.5 | 542 | 0.2% |
| 360 | 539 | 0.2% |
| 298.3783784 | 524 | 0.2% |
| 408 | 521 | 0.2% |
| Other values (10436) | 330659 |
| Value | Count | Frequency (%) |
| 6.769022238 | 1 | < 0.1% |
| 31.8542223 | 1 | < 0.1% |
| 37.4287112 | 81 | < 0.1% |
| 38.22506675 | 9 | < 0.1% |
| 46.18862233 | 31 | < 0.1% |
| 56.93942235 | 21 | < 0.1% |
| 63.70844459 | 18 | < 0.1% |
| 67.2920446 | 21 | < 0.1% |
| 68.88475571 | 11 | < 0.1% |
| 73.26471128 | 354 |
| Value | Count | Frequency (%) |
| 1976.156316 | 6 | < 0.1% |
| 1029.687736 | 95 | |
| 1025.705958 | 3 | < 0.1% |
| 1022.918713 | 1 | < 0.1% |
| 1021.326002 | 63 | |
| 1003.80618 | 2 | < 0.1% |
| 985.4900023 | 103 | |
| 981.5082245 | 8 | < 0.1% |
| 977.1282689 | 49 | |
| 973.9428467 | 19 | < 0.1% |
month_name
Categorical
High correlation 
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 19.3 MiB |
| Jul | |
|---|---|
| Aug | |
| Oct | |
| Mar | |
| May | |
| Other values (7) |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Jan |
|---|---|
| 2nd row | Jan |
| 3rd row | Jan |
| 4th row | Jan |
| 5th row | Jan |
Common Values
| Value | Count | Frequency (%) |
| Jul | 29425 | |
| Aug | 29327 | |
| Oct | 28889 | |
| Mar | 28834 | |
| May | 28796 | |
| Apr | 28330 | |
| Jun | 28243 | |
| Dec | 28135 | |
| Sep | 27574 | |
| Nov | 27268 | |
| Other values (2) | 51955 |
Length
| Value | Count | Frequency (%) |
| jul | 29425 | |
| aug | 29327 | |
| oct | 28889 | |
| mar | 28834 | |
| may | 28796 | |
| apr | 28330 | |
| jun | 28243 | |
| dec | 28135 | |
| sep | 27574 | |
| nov | 27268 | |
| Other values (2) | 51955 |
Most occurring characters
| Value | Count | Frequency (%) |
| u | 86995 | 8.6% |
| J | 84672 | 8.4% |
| a | 84634 | 8.4% |
| e | 80660 | 8.0% |
| A | 57657 | 5.7% |
| M | 57630 | 5.7% |
| r | 57164 | 5.7% |
| c | 57024 | 5.6% |
| p | 55904 | 5.5% |
| n | 55247 | 5.5% |
| Other values (12) | 332741 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 673552 | |
| Uppercase Letter | 336776 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| u | 86995 | |
| a | 84634 | |
| e | 80660 | |
| r | 57164 | |
| c | 57024 | |
| p | 55904 | |
| n | 55247 | |
| l | 29425 | 4.4% |
| g | 29327 | 4.4% |
| t | 28889 | 4.3% |
| Other values (4) | 108283 |
Uppercase Letter
| Value | Count | Frequency (%) |
| J | 84672 | |
| A | 57657 | |
| M | 57630 | |
| O | 28889 | 8.6% |
| D | 28135 | 8.4% |
| S | 27574 | 8.2% |
| N | 27268 | 8.1% |
| F | 24951 | 7.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1010328 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| u | 86995 | 8.6% |
| J | 84672 | 8.4% |
| a | 84634 | 8.4% |
| e | 80660 | 8.0% |
| A | 57657 | 5.7% |
| M | 57630 | 5.7% |
| r | 57164 | 5.7% |
| c | 57024 | 5.6% |
| p | 55904 | 5.5% |
| n | 55247 | 5.5% |
| Other values (12) | 332741 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1010328 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| u | 86995 | 8.6% |
| J | 84672 | 8.4% |
| a | 84634 | 8.4% |
| e | 80660 | 8.0% |
| A | 57657 | 5.7% |
| M | 57630 | 5.7% |
| r | 57164 | 5.7% |
| c | 57024 | 5.6% |
| p | 55904 | 5.5% |
| n | 55247 | 5.5% |
| Other values (12) | 332741 |
Interactions
Correlations
| air_time | arr_delay | arr_time | carrier | day | dep_delay | dep_time | distance | flight | hour | minute | month | month_name | origin | sched_arr_time | sched_dep_time | speed | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| air_time | 1.000 | -0.013 | 0.055 | 0.355 | 0.001 | 0.085 | -0.029 | 0.962 | -0.462 | -0.027 | 0.033 | 0.002 | 0.047 | 0.243 | 0.079 | -0.025 | 0.651 |
| arr_delay | -0.013 | 1.000 | 0.120 | 0.038 | -0.002 | 0.639 | 0.206 | -0.078 | 0.075 | 0.160 | 0.022 | -0.018 | 0.040 | 0.022 | 0.127 | 0.161 | -0.247 |
| arr_time | 0.055 | 0.120 | 1.000 | 0.107 | -0.004 | 0.190 | 0.807 | 0.052 | 0.009 | 0.774 | 0.057 | -0.003 | 0.027 | 0.117 | 0.860 | 0.776 | 0.018 |
| carrier | 0.355 | 0.038 | 0.107 | 1.000 | 0.000 | 0.032 | 0.107 | 0.381 | 0.457 | 0.110 | 0.106 | 0.014 | 0.012 | 0.591 | 0.135 | 0.112 | 0.185 |
| day | 0.001 | -0.002 | -0.004 | 0.000 | 1.000 | 0.003 | -0.000 | 0.004 | -0.000 | -0.000 | 0.001 | 0.003 | 0.037 | 0.000 | -0.002 | -0.000 | 0.010 |
| dep_delay | 0.085 | 0.639 | 0.190 | 0.032 | 0.003 | 1.000 | 0.289 | 0.060 | -0.010 | 0.234 | 0.060 | -0.020 | 0.029 | 0.019 | 0.220 | 0.237 | 0.034 |
| dep_time | -0.029 | 0.206 | 0.807 | 0.107 | -0.000 | 0.289 | 1.000 | -0.028 | 0.033 | 0.957 | 0.090 | -0.004 | 0.021 | 0.111 | 0.868 | 0.959 | -0.020 |
| distance | 0.962 | -0.078 | 0.052 | 0.381 | 0.004 | 0.060 | -0.028 | 1.000 | -0.483 | -0.035 | 0.035 | 0.020 | 0.021 | 0.274 | 0.072 | -0.033 | 0.792 |
| flight | -0.462 | 0.075 | 0.009 | 0.457 | -0.000 | -0.010 | 0.033 | -0.483 | 1.000 | 0.032 | 0.004 | 0.004 | 0.067 | 0.320 | 0.002 | 0.032 | -0.396 |
| hour | -0.027 | 0.160 | 0.774 | 0.110 | -0.000 | 0.234 | 0.957 | -0.035 | 0.032 | 1.000 | 0.034 | -0.005 | 0.010 | 0.093 | 0.880 | 0.998 | -0.028 |
| minute | 0.033 | 0.022 | 0.057 | 0.106 | 0.001 | 0.060 | 0.090 | 0.035 | 0.004 | 0.034 | 1.000 | 0.014 | 0.027 | 0.125 | 0.063 | 0.095 | 0.037 |
| month | 0.002 | -0.018 | -0.003 | 0.014 | 0.003 | -0.020 | -0.004 | 0.020 | 0.004 | -0.005 | 0.014 | 1.000 | 1.000 | 0.020 | -0.005 | -0.005 | 0.067 |
| month_name | 0.047 | 0.040 | 0.027 | 0.012 | 0.037 | 0.029 | 0.021 | 0.021 | 0.067 | 0.010 | 0.027 | 1.000 | 1.000 | 0.020 | 0.016 | 0.010 | 0.097 |
| origin | 0.243 | 0.022 | 0.117 | 0.591 | 0.000 | 0.019 | 0.111 | 0.274 | 0.320 | 0.093 | 0.125 | 0.020 | 0.020 | 1.000 | 0.137 | 0.115 | 0.083 |
| sched_arr_time | 0.079 | 0.127 | 0.860 | 0.135 | -0.002 | 0.220 | 0.868 | 0.072 | 0.002 | 0.880 | 0.063 | -0.005 | 0.016 | 0.137 | 1.000 | 0.882 | 0.042 |
| sched_dep_time | -0.025 | 0.161 | 0.776 | 0.112 | -0.000 | 0.237 | 0.959 | -0.033 | 0.032 | 0.998 | 0.095 | -0.005 | 0.010 | 0.115 | 0.882 | 1.000 | -0.025 |
| speed | 0.651 | -0.247 | 0.018 | 0.185 | 0.010 | 0.034 | -0.020 | 0.792 | -0.396 | -0.028 | 0.037 | 0.067 | 0.097 | 0.083 | 0.042 | -0.025 | 1.000 |
Missing values
Sample
| year | month | day | dep_time | sched_dep_time | dep_delay | arr_time | sched_arr_time | arr_delay | carrier | flight | tailnum | origin | dest | air_time | distance | hour | minute | time_hour | speed | month_name | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2013 | 1 | 1 | 517.0 | 515 | 2.0 | 830.0 | 819 | 11.0 | UA | 1545 | N14228 | EWR | IAH | 227.0 | 1400 | 5 | 15 | 1/1/2013 5:00 | 370.044053 | Jan |
| 1 | 2013 | 1 | 1 | 533.0 | 529 | 4.0 | 850.0 | 830 | 20.0 | UA | 1714 | N24211 | LGA | IAH | 227.0 | 1416 | 5 | 29 | 1/1/2013 5:00 | 374.273128 | Jan |
| 2 | 2013 | 1 | 1 | 542.0 | 540 | 2.0 | 923.0 | 850 | 33.0 | AA | 1141 | N619AA | JFK | MIA | 160.0 | 1089 | 5 | 40 | 1/1/2013 5:00 | 408.375000 | Jan |
| 3 | 2013 | 1 | 1 | 544.0 | 545 | -1.0 | 1004.0 | 1022 | -18.0 | B6 | 725 | N804JB | JFK | BQN | 183.0 | 1576 | 5 | 45 | 1/1/2013 5:00 | 516.721311 | Jan |
| 4 | 2013 | 1 | 1 | 554.0 | 600 | -6.0 | 812.0 | 837 | -25.0 | DL | 461 | N668DN | LGA | ATL | 116.0 | 762 | 6 | 0 | 1/1/2013 6:00 | 394.137931 | Jan |
| 5 | 2013 | 1 | 1 | 554.0 | 558 | -4.0 | 740.0 | 728 | 12.0 | UA | 1696 | N39463 | EWR | ORD | 150.0 | 719 | 5 | 58 | 1/1/2013 5:00 | 287.600000 | Jan |
| 6 | 2013 | 1 | 1 | 555.0 | 600 | -5.0 | 913.0 | 854 | 19.0 | B6 | 507 | N516JB | EWR | FLL | 158.0 | 1065 | 6 | 0 | 1/1/2013 6:00 | 404.430380 | Jan |
| 7 | 2013 | 1 | 1 | 557.0 | 600 | -3.0 | 709.0 | 723 | -14.0 | EV | 5708 | N829AS | LGA | IAD | 53.0 | 229 | 6 | 0 | 1/1/2013 6:00 | 259.245283 | Jan |
| 8 | 2013 | 1 | 1 | 557.0 | 600 | -3.0 | 838.0 | 846 | -8.0 | B6 | 79 | N593JB | JFK | MCO | 140.0 | 944 | 6 | 0 | 1/1/2013 6:00 | 404.571429 | Jan |
| 9 | 2013 | 1 | 1 | 558.0 | 600 | -2.0 | 753.0 | 745 | 8.0 | AA | 301 | N3ALAA | LGA | ORD | 138.0 | 733 | 6 | 0 | 1/1/2013 6:00 | 318.695652 | Jan |
| year | month | day | dep_time | sched_dep_time | dep_delay | arr_time | sched_arr_time | arr_delay | carrier | flight | tailnum | origin | dest | air_time | distance | hour | minute | time_hour | speed | month_name | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 336766 | 2013 | 9 | 30 | 2240.000000 | 2250 | -10.00000 | 2347.000000 | 7 | -20.000000 | B6 | 2002 | N281JB | JFK | BUF | 52.00000 | 301 | 22 | 50 | 30-09-2013 22:00 | 347.307692 | Sep |
| 336767 | 2013 | 9 | 30 | 2241.000000 | 2246 | -5.00000 | 2345.000000 | 1 | -16.000000 | B6 | 486 | N346JB | JFK | ROC | 47.00000 | 264 | 22 | 46 | 30-09-2013 22:00 | 337.021277 | Sep |
| 336768 | 2013 | 9 | 30 | 2307.000000 | 2255 | 12.00000 | 2359.000000 | 2358 | 1.000000 | B6 | 718 | N565JB | JFK | BOS | 33.00000 | 187 | 22 | 55 | 30-09-2013 22:00 | 340.000000 | Sep |
| 336769 | 2013 | 9 | 30 | 2349.000000 | 2359 | -10.00000 | 325.000000 | 350 | -25.000000 | B6 | 745 | N516JB | JFK | PSE | 196.00000 | 1617 | 23 | 59 | 30-09-2013 23:00 | 495.000000 | Sep |
| 336770 | 2013 | 9 | 30 | 1349.109947 | 1842 | 12.63907 | 1502.054999 | 2019 | 6.895377 | EV | 5274 | N740EV | LGA | BNA | 150.68646 | 764 | 18 | 42 | 30-09-2013 18:00 | 304.207823 | Sep |
| 336771 | 2013 | 9 | 30 | 1349.109947 | 1455 | 12.63907 | 1502.054999 | 1634 | 6.895377 | 9E | 3393 | N725MQ | JFK | DCA | 150.68646 | 213 | 14 | 55 | 30-09-2013 14:00 | 84.811867 | Sep |
| 336772 | 2013 | 9 | 30 | 1349.109947 | 2200 | 12.63907 | 1502.054999 | 2312 | 6.895377 | 9E | 3525 | N725MQ | LGA | SYR | 150.68646 | 198 | 22 | 0 | 30-09-2013 22:00 | 78.839200 | Sep |
| 336773 | 2013 | 9 | 30 | 1349.109947 | 1210 | 12.63907 | 1502.054999 | 1330 | 6.895377 | MQ | 3461 | N535MQ | LGA | BNA | 150.68646 | 764 | 12 | 10 | 30-09-2013 12:00 | 304.207823 | Sep |
| 336774 | 2013 | 9 | 30 | 1349.109947 | 1159 | 12.63907 | 1502.054999 | 1344 | 6.895377 | MQ | 3572 | N511MQ | LGA | CLE | 150.68646 | 419 | 11 | 59 | 30-09-2013 11:00 | 166.836489 | Sep |
| 336775 | 2013 | 9 | 30 | 1349.109947 | 840 | 12.63907 | 1502.054999 | 1020 | 6.895377 | MQ | 3531 | N839MQ | LGA | RDU | 150.68646 | 431 | 8 | 40 | 30-09-2013 08:00 | 171.614623 | Sep |